Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TimePunchEntryID (PK) | A unique system-assigned identifier for this particular TimePunchEntry | ID_ENR_TPNCH | Identity | integer | |
TaskID (FK) | A unique retailer assigned identifier for an individual activity that a Worker performs in the course of their Position. | ID_TSK | Identity | integer | Task(CO_TSK) |
WorkerID (FK) | A unique system-assigned identifier for the Person who is a particular Worker. | ID_WRKR | Identity | integer | Worker(PA_WRKR) |
JobID (FK) | A unique retailer assigned identifier for a particular Job. | ID_JOB | Identity | integer | Job(CO_JOB) |
BusinessDayDate (FK) | The calendar date of the BusinessDay. | DC_DY_BSN | DateCalendar | date | BusinessDay(CA_DY_BSN) |
TimePunchDateTime | The date and time of the TimePunch as recorded by the TimeClock or Workstation that was used to make it. | DC_TPNCH | AuditDateTime | datetime | |
TimeClockID (FK) | A unqiue system-assigned number identifying a particular TimeClock | ID_TCLK | Identity | integer | TimeClock(PA_TCLK) |
TransactionID (FK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | TimePunchTransaction(TR_TPNCH) |
SiteID (FK) | Token ID for a Site | ID_STE | Identity | integer | Site(LO_STE) |